
-- Text indexes should be created after any test data is loaded into our database.
-- This makes sure the index is up to date and searches in unit tests can find
-- our test data.

-- Create text index catalogue

sp_fulltext_database 'enable'
CREATE FULLTEXT CATALOG GdnwCat WITH accent_sensitivity = OFF AS DEFAULT  

-- Text Index for Charges searching

CREATE FULLTEXT INDEX ON Charge (Name) 
KEY INDEX PK_Charge WITH CHANGE_TRACKING AUTO
GO
